/*******************************************************************************
 * This file is part of blueprint4j www.blueprint4j.org.
 * 
 *     blueprint4j is free software: you can redistribute it and/or modify
 *     it under the terms of the GNU Lesser General Public License as published by
 *     the Free Software Foundation, either version 3 of the License, or
 *     (at your option) any later version.
 * 
 *     blueprint4j is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU Lesser General Public License for more details.
 * 
 *     You should have received a copy of the GNU Lesser General Public License
 *     along with blueprint4j. If not, see <http://www.gnu.org/licenses/>.
 ******************************************************************************/
package blueprint4j.db;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.text.DateFormat;
import java.text.ParseException;
import java.util.Date;
import java.sql.*;

import blueprint4j.utils.*;

public class FieldBoolean extends Field implements BindBooleanInterface{
    
    /**
     * Consrtucts a new FieldBoolean with name and field types
     */
    public FieldBoolean( String p_name, int p_field_type ,String p_description,Entity entity ) {
        super( p_name,p_field_type,p_description,entity );
    }
    
    public Field newInstance(Entity entity) {
        return new FieldBoolean(getName(),getFieldType(),getDescription(),entity);
    }
    
    /**
     * Set Value field type bigdecimal, retrieved from ResultSet
     */
    protected void setFieldValue( ResultSet result_set )
    throws DataException {
        try {
            String value=result_set.getString(getName());
            if (value==null){
                setObject(null);
            }else{
                setObject( new Boolean(value.equalsIgnoreCase("Y")) );
            }
        } catch ( SQLException se ) {
            throw new DataException( "Can not retrieve '" + getName() + "'" );
        };
    }
    
    public Boolean get() {
        return (Boolean) getObject();
    }
    
    public void set(Boolean value){
        setObject(value);
    }
    
    public String toString(){
        if (getObject() == null) {
            return null;
        }
        return getObject().toString();
    }
    
    /**
     * Return data in a suitable SQL format
     */
    public String getSQLValue()
    throws DataException {
        return getSQLForBoolean(get());
    }
    
    /**
     * An overloaded equals method that only accepts big decimal
     */
    public boolean equals(Boolean value) {
        return get().equals(value);
    }
    
    public static String getSQLForBoolean(Boolean value) {
        if (value == null) {
            return "null";
        }
        if (value.booleanValue()) {
            return "'Y'";
        } else {
            return "'N'";
        }
    }
    
    public Object getPreparedStatementObject()
    throws DataException {
        if (getObject() == null) return null;
        if (get().booleanValue()) {
            return "Y";
        } else {
            return "N";
        }
    }
    
    public void setSerializable(String value) throws BindException{
        if ("null".equalsIgnoreCase(""+value)) {
            setObject(null);
        } else {
            setObject(new Boolean(value));
        }
    }
    
}
